Use PEGetSQLQuery to retrieve the same query that appears in the Show SQL Query dialog box in Crystal Reports, in a syntax that's specific to the database driver you're using. Use this function with PEGetHandleString. Use PESetSQLQuery, to update the query. See Remarks below.
BOOL CRPE_API PEGetSQLQuery (
short printJob,
HANDLE FAR *textHandle,
short FAR *textLength );
The report must be logged on before the call to PEGetSQLQuery is made.
Declare Function PEGetSQLQuery Lib "crpe32.dll" ( ByVal printJob As Integer, TextHandle As Long, TextLength As Integer ) As Integer
function PEGetSQLQuery (
printJob: Word;
var textHandle: HWnd;
var textLength: Word
): Bool stdcall;
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |